CREATE TABLE [dbo].[tb_AsignaturasPosiblesEC]
(
[idEspacioCurricular] [int] NOT NULL,
[idAsignatura] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [idx_key] ON [dbo].[tb_AsignaturasPosiblesEC] ([idEspacioCurricular], [idAsignatura]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_AsignaturasPosiblesEC] WITH NOCHECK ADD CONSTRAINT [FK_tb_AsignaturasPosiblesEC_tb_EspaciosCurriculares] FOREIGN KEY ([idEspacioCurricular]) REFERENCES [dbo].[tb_EspaciosCurriculares] ([idEspacioCurricular])
GO
ALTER TABLE [dbo].[tb_AsignaturasPosiblesEC] NOCHECK CONSTRAINT [FK_tb_AsignaturasPosiblesEC_tb_EspaciosCurriculares]
GO
